package com.system.user.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.system.user.entity.BindEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface BindDao {

    int insertBind(@Param("uId") int uId, @Param("bNumber") String bNumber);

    int deleteBind(@Param("id") Integer id);

    int deleteBindByBNumber(@Param("bNumber") String bNumber);

    int deleteBindByUid(@Param("uId") Integer uId);

    int deleteByUidAndBNumber(@Param("uId") Integer uId, @Param("bNumber") String bNumber);

    List<BindEntity> queryByUidAndBNumber(@Param("uId") Integer uId, @Param("bNumber") String bNumber);

    String queryByBNumber(@Param("bNumber") String bNumber);
}
